package com.pantuo.sys.dao;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pantuo.sys.pojo.Vehicle;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface VehicleDao /*extends BaseMapper<Vehicle>*/ {

    //根据线路id查找出线路的名称以及对应的id
    public List<Map<String, Object>> findAllNames(Integer id);

    //根据车辆编号查出车辆id和公司名称
    public List<Map<String, Object>> findIdAndCNameByNum(String vehicleNum2_s);

    //根据线路id查出车辆数量
    public Map<String, Object> findTotalByVId(Integer id);

    public List<Map<String, Object>> findAllObjects(@Param("map1") Map<String, String> map1,
                                                    @Param("map2") Map<String, String> map2,
                                                    Integer start,
                                                    Integer length
    );

    public Long getTotal(@Param("map1") Map<String, String> map1);

    public Long getTotal2(@Param("map1") Map<String, String> map1);

    public int findCountForVehicle(String startDate, String endDate);

    public int findThisMonthCount(String date_s);

    public List<Map<String, Object>> findAllObjects2(@Param("map1") Map<String, String> map1,
                                                    @Param("orderList") List<Map<String, String>> orderList,
                                                    Integer start,
                                                    Integer length
    );

}
